Overview
Brought to you by YData
Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 4877540 |
| Missing cells | 5010280 |
| Missing cells (%) | 4.9% |
| Duplicate rows | 17 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 781.5 MiB |
| Average record size in memory | 168.0 B |
Variable types
| Text | 2 |
|---|---|
| Numeric | 12 |
| Categorical | 3 |
| DateTime | 2 |
| Unsupported | 2 |
| Dataset has 17 (< 0.1%) duplicate rows | Duplicates |
cd_centro_custo is highly overall correlated with ds_estabelecimento | High correlation |
cd_local_estoque is highly overall correlated with ds_estabelecimento | High correlation |
cd_material is highly overall correlated with id_item | High correlation |
cd_operacao is highly overall correlated with ds_operacao and 1 other fields | High correlation |
ds_estabelecimento is highly overall correlated with cd_centro_custo and 1 other fields | High correlation |
ds_operacao is highly overall correlated with cd_operacao | High correlation |
id_item is highly overall correlated with cd_material | High correlation |
qt_consumo is highly overall correlated with cd_operacao and 1 other fields | High correlation |
qt_estoque is highly overall correlated with qt_consumo | High correlation |
vl_consumo is highly overall correlated with vl_estoque and 2 other fields | High correlation |
vl_estoque is highly overall correlated with vl_consumo and 2 other fields | High correlation |
vl_movimento is highly overall correlated with vl_consumo and 2 other fields | High correlation |
vl_movimento_2 is highly overall correlated with vl_consumo and 2 other fields | High correlation |
ds_estabelecimento is highly imbalanced (94.3%) | Imbalance |
cd_acao is highly imbalanced (99.3%) | Imbalance |
ds_operacao is highly imbalanced (85.9%) | Imbalance |
nr_atendimento has 132655 (2.7%) missing values | Missing |
nr_lote_contabil has 4877540 (100.0%) missing values | Missing |
cd_centro_custo is highly skewed (γ1 = -25.00265505) | Skewed |
cd_operacao is highly skewed (γ1 = 25.00912097) | Skewed |
qt_estoque is highly skewed (γ1 = 2190.824078) | Skewed |
vl_estoque is highly skewed (γ1 = 271.0042698) | Skewed |
vl_movimento is highly skewed (γ1 = 271.0042698) | Skewed |
vl_consumo is highly skewed (γ1 = 271.8533025) | Skewed |
qt_consumo is highly skewed (γ1 = 2191.238896) | Skewed |
vl_movimento_2 is highly skewed (γ1 = 271.8533025) | Skewed |
cd_conta_contabil is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
nr_lote_contabil is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2025-09-26 21:04:17.649618 |
|---|---|
| Analysis finished | 2025-09-26 21:09:37.779827 |
| Duration | 5 minutes and 20.13 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
Variables
ds_centro_custo
Text
| Distinct | 220 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 37.2 MiB |
Length
| Max length | 54 |
|---|---|
| Median length | 50 |
| Mean length | 24.281995 |
| Min length | 3 |
Unique
| Unique | 25 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Posto Carambeí |
|---|---|
| 2nd row | SADT - RADIOLOGIA |
| 3rd row | Coleta Ambulatorial |
| 4th row | 3º ANDAR - UNIDADE DE INTERNAÇÃO |
| 5th row | 3º ANDAR - UNIDADE DE INTERNAÇÃO |
| Value | Count | Frequency (%) |
| de | 2224137 | 11.2% |
| unidade | 2116502 | 10.6% |
| internação | 2109717 | 10.6% |
| 1814792 | 9.1% | |
| andar | 1744095 | 8.7% |
| centro | 1065732 | 5.3% |
| cirúrgico | 963438 | 4.8% |
| unimed | 837602 | 4.2% |
| 24 | 678581 | 3.4% |
| horas | 678581 | 3.4% |
| Other values (271) | 5708350 |
Most occurring characters
| Value | Count | Frequency (%) |
| 15093392 | ||
| A | 9672749 | 8.2% |
| N | 9660202 | 8.2% |
| I | 9590087 | 8.1% |
| D | 8894184 | 7.5% |
| R | 8801372 | 7.4% |
| E | 8708351 | 7.4% |
| O | 6592818 | 5.6% |
| T | 5563631 | 4.7% |
| U | 4400999 | 3.7% |
| Other values (66) | 31458618 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 118436403 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 15093392 | ||
| A | 9672749 | 8.2% |
| N | 9660202 | 8.2% |
| I | 9590087 | 8.1% |
| D | 8894184 | 7.5% |
| R | 8801372 | 7.4% |
| E | 8708351 | 7.4% |
| O | 6592818 | 5.6% |
| T | 5563631 | 4.7% |
| U | 4400999 | 3.7% |
| Other values (66) | 31458618 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 118436403 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 15093392 | ||
| A | 9672749 | 8.2% |
| N | 9660202 | 8.2% |
| I | 9590087 | 8.1% |
| D | 8894184 | 7.5% |
| R | 8801372 | 7.4% |
| E | 8708351 | 7.4% |
| O | 6592818 | 5.6% |
| T | 5563631 | 4.7% |
| U | 4400999 | 3.7% |
| Other values (66) | 31458618 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 118436403 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 15093392 | ||
| A | 9672749 | 8.2% |
| N | 9660202 | 8.2% |
| I | 9590087 | 8.1% |
| D | 8894184 | 7.5% |
| R | 8801372 | 7.4% |
| E | 8708351 | 7.4% |
| O | 6592818 | 5.6% |
| T | 5563631 | 4.7% |
| U | 4400999 | 3.7% |
| Other values (66) | 31458618 |
cd_centro_custo
Real number (ℝ)
High correlation Skewed
| Distinct | 224 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9104.8642 |
| Minimum | 101 |
|---|---|
| Maximum | 19334 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 37.2 MiB |
Quantile statistics
| Minimum | 101 |
|---|---|
| 5-th percentile | 9101 |
| Q1 | 9107 |
| median | 9108 |
| Q3 | 9124 |
| 95-th percentile | 9143 |
| Maximum | 19334 |
| Range | 19233 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 288.21908 |
|---|---|
| Coefficient of variation (CV) | 0.031655506 |
| Kurtosis | 711.0801 |
| Mean | 9104.8642 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | -25.002655 |
| Sum | 4.440934 × 1010 |
| Variance | 83070.24 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9108 | 962092 | |
| 9109 | 677102 | |
| 9107 | 505888 | |
| 9103 | 453493 | |
| 9101 | 439363 | |
| 9143 | 384940 | |
| 9124 | 365621 | 7.5% |
| 9102 | 272906 | 5.6% |
| 9142 | 193391 | 4.0% |
| 9137 | 185906 | 3.8% |
| Other values (214) | 436838 |
| Value | Count | Frequency (%) |
| 101 | 129 | |
| 105 | 55 | |
| 107 | 16 | < 0.1% |
| 108 | 60 | |
| 110 | 50 | < 0.1% |
| 111 | 92 | |
| 112 | 1 | < 0.1% |
| 113 | 15 | < 0.1% |
| 209 | 21 | < 0.1% |
| 214 | 17 | < 0.1% |
| Value | Count | Frequency (%) |
| 19334 | 6 | < 0.1% |
| 19307 | 1 | < 0.1% |
| 19306 | 11 | < 0.1% |
| 19304 | 1 | < 0.1% |
| 19135 | 1 | < 0.1% |
| 19114 | 6 | < 0.1% |
| 19102 | 1 | < 0.1% |
| 11404 | 1 | < 0.1% |
| 9811 | 1 | < 0.1% |
| 9801 | 297 |
ds_estabelecimento
Categorical
High correlation Imbalance
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 37.2 MiB |
| Hospital Geral Unimed | |
|---|---|
| Laboratorio Unimed Ponta Grossa | 31480 |
| ESU Telêmaco Borba - Klabin | 24151 |
| Espaço Saúde Unimed | 9859 |
| Unimed Ponta Grossa | 4166 |
Length
| Max length | 31 |
|---|---|
| Median length | 21 |
| Mean length | 21.088499 |
| Min length | 19 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Laboratorio Unimed Ponta Grossa |
|---|---|
| 2nd row | Hospital Geral Unimed |
| 3rd row | Laboratorio Unimed Ponta Grossa |
| 4th row | Hospital Geral Unimed |
| 5th row | Hospital Geral Unimed |
Common Values
| Value | Count | Frequency (%) |
| Hospital Geral Unimed | 4807884 | |
| Laboratorio Unimed Ponta Grossa | 31480 | 0.6% |
| ESU Telêmaco Borba - Klabin | 24151 | 0.5% |
| Espaço Saúde Unimed | 9859 | 0.2% |
| Unimed Ponta Grossa | 4166 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| unimed | 4853389 | |
| hospital | 4807884 | |
| geral | 4807884 | |
| ponta | 35646 | 0.2% |
| grossa | 35646 | 0.2% |
| laboratorio | 31480 | 0.2% |
| esu | 24151 | 0.2% |
| telêmaco | 24151 | 0.2% |
| borba | 24151 | 0.2% |
| 24151 | 0.2% | |
| Other values (3) | 43869 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 9842191 | 9.6% |
| 9834862 | 9.6% | |
| i | 9716904 | 9.4% |
| e | 9695283 | 9.4% |
| l | 9664070 | 9.4% |
| o | 5031777 | 4.9% |
| r | 4930641 | 4.8% |
| n | 4913186 | 4.8% |
| s | 4889035 | 4.8% |
| m | 4877540 | 4.7% |
| Other values (19) | 29464507 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 102859996 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 9842191 | 9.6% |
| 9834862 | 9.6% | |
| i | 9716904 | 9.4% |
| e | 9695283 | 9.4% |
| l | 9664070 | 9.4% |
| o | 5031777 | 4.9% |
| r | 4930641 | 4.8% |
| n | 4913186 | 4.8% |
| s | 4889035 | 4.8% |
| m | 4877540 | 4.7% |
| Other values (19) | 29464507 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 102859996 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 9842191 | 9.6% |
| 9834862 | 9.6% | |
| i | 9716904 | 9.4% |
| e | 9695283 | 9.4% |
| l | 9664070 | 9.4% |
| o | 5031777 | 4.9% |
| r | 4930641 | 4.8% |
| n | 4913186 | 4.8% |
| s | 4889035 | 4.8% |
| m | 4877540 | 4.7% |
| Other values (19) | 29464507 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 102859996 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 9842191 | 9.6% |
| 9834862 | 9.6% | |
| i | 9716904 | 9.4% |
| e | 9695283 | 9.4% |
| l | 9664070 | 9.4% |
| o | 5031777 | 4.9% |
| r | 4930641 | 4.8% |
| n | 4913186 | 4.8% |
| s | 4889035 | 4.8% |
| m | 4877540 | 4.7% |
| Other values (19) | 29464507 |
cd_material
Real number (ℝ)
High correlation
| Distinct | 3637 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25426.129 |
| Minimum | 2 |
|---|---|
| Maximum | 79674 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 37.2 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 69 |
| Q1 | 238 |
| median | 4242 |
| Q3 | 52139 |
| 95-th percentile | 73864 |
| Maximum | 79674 |
| Range | 79672 |
| Interquartile range (IQR) | 51901 |
Descriptive statistics
| Standard deviation | 28179.3 |
|---|---|
| Coefficient of variation (CV) | 1.1082812 |
| Kurtosis | -1.5141952 |
| Mean | 25426.129 |
| Median Absolute Deviation (MAD) | 4174 |
| Skewness | 0.46251779 |
| Sum | 1.2401696 × 1011 |
| Variance | 7.9407292 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 51823 | 540978 | 11.1% |
| 69 | 328797 | 6.7% |
| 2358 | 286057 | 5.9% |
| 68 | 167287 | 3.4% |
| 53709 | 156174 | 3.2% |
| 342 | 153863 | 3.2% |
| 90 | 140266 | 2.9% |
| 11325 | 116066 | 2.4% |
| 193 | 107909 | 2.2% |
| 73864 | 92689 | 1.9% |
| Other values (3627) | 2787454 |
| Value | Count | Frequency (%) |
| 2 | 60 | < 0.1% |
| 32 | 1258 | < 0.1% |
| 35 | 1569 | < 0.1% |
| 36 | 1298 | < 0.1% |
| 37 | 181 | < 0.1% |
| 38 | 1503 | < 0.1% |
| 40 | 7492 | 0.2% |
| 55 | 6775 | 0.1% |
| 61 | 16 | < 0.1% |
| 68 | 167287 |
| Value | Count | Frequency (%) |
| 79674 | 1 | < 0.1% |
| 79629 | 1 | < 0.1% |
| 79628 | 1 | < 0.1% |
| 79594 | 1 | < 0.1% |
| 79574 | 1 | < 0.1% |
| 79548 | 156 | |
| 79547 | 24 | < 0.1% |
| 79546 | 66 | |
| 79545 | 63 | |
| 79534 | 2 | < 0.1% |
cd_acao
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 37.2 MiB |
| 1 | |
|---|---|
| 2 | 2672 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 4874868 | |
| 2 | 2672 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 4874868 | |
| 2 | 2672 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 4874868 | |
| 2 | 2672 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4877540 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 4874868 | |
| 2 | 2672 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4877540 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 4874868 | |
| 2 | 2672 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4877540 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 4874868 | |
| 2 | 2672 | 0.1% |
nr_atendimento
Real number (ℝ)
Missing
| Distinct | 134087 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 132655 |
| Missing (%) | 2.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2275040.8 |
| Minimum | 2140 |
|---|---|
| Maximum | 2635382 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 37.2 MiB |
Quantile statistics
| Minimum | 2140 |
|---|---|
| 5-th percentile | 1940154 |
| Q1 | 2063674 |
| median | 2297411 |
| Q3 | 2475582 |
| 95-th percentile | 2604612 |
| Maximum | 2635382 |
| Range | 2633242 |
| Interquartile range (IQR) | 411908 |
Descriptive statistics
| Standard deviation | 224912.51 |
|---|---|
| Coefficient of variation (CV) | 0.098860871 |
| Kurtosis | -0.95951814 |
| Mean | 2275040.8 |
| Median Absolute Deviation (MAD) | 207437 |
| Skewness | -0.16531884 |
| Sum | 1.0794807 × 1013 |
| Variance | 5.0585638 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2255730 | 14999 | 0.3% |
| 2314032 | 14414 | 0.3% |
| 1498648 | 12830 | 0.3% |
| 2156854 | 8873 | 0.2% |
| 2564269 | 8678 | 0.2% |
| 2475582 | 7524 | 0.2% |
| 1976232 | 7337 | 0.2% |
| 2339356 | 7318 | 0.2% |
| 2516629 | 7265 | 0.1% |
| 1940058 | 7071 | 0.1% |
| Other values (134077) | 4648576 | |
| (Missing) | 132655 | 2.7% |
| Value | Count | Frequency (%) |
| 2140 | 2 | < 0.1% |
| 235215 | 1 | < 0.1% |
| 252646 | 2 | < 0.1% |
| 296365 | 11 | < 0.1% |
| 459842 | 1 | < 0.1% |
| 1056530 | 5 | < 0.1% |
| 1137099 | 188 | < 0.1% |
| 1284595 | 634 | < 0.1% |
| 1498648 | 12830 | |
| 1565052 | 196 | < 0.1% |
| Value | Count | Frequency (%) |
| 2635382 | 11 | < 0.1% |
| 2635381 | 4 | < 0.1% |
| 2635380 | 12 | < 0.1% |
| 2635379 | 5 | < 0.1% |
| 2635376 | 11 | < 0.1% |
| 2635373 | 12 | < 0.1% |
| 2635368 | 24 | |
| 2635363 | 40 | |
| 2635361 | 55 | |
| 2635360 | 17 | < 0.1% |
dt_movimento_estoque
Date
| Distinct | 1522221 |
|---|---|
| Distinct (%) | 31.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 37.2 MiB |
| Minimum | 2011-07-22 10:00:00 |
|---|---|
| Maximum | 2024-12-31 23:53:10 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
cd_local_estoque
Real number (ℝ)
High correlation
| Distinct | 61 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.321213 |
| Minimum | 1 |
|---|---|
| Maximum | 565 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 37.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 12 |
| 95-th percentile | 57 |
| Maximum | 565 |
| Range | 564 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 81.374238 |
|---|---|
| Coefficient of variation (CV) | 4.0043987 |
| Kurtosis | 34.170705 |
| Mean | 20.321213 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.9574757 |
| Sum | 99117527 |
| Variance | 6621.7665 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 2797386 | |
| 12 | 1002612 | 20.6% |
| 15 | 756741 | 15.5% |
| 57 | 129146 | 2.6% |
| 506 | 49799 | 1.0% |
| 11 | 46986 | 1.0% |
| 551 | 23356 | 0.5% |
| 62 | 17734 | 0.4% |
| 515 | 15514 | 0.3% |
| 561 | 7968 | 0.2% |
| Other values (51) | 30298 | 0.6% |
| Value | Count | Frequency (%) |
| 1 | 2797386 | |
| 11 | 46986 | 1.0% |
| 12 | 1002612 | 20.6% |
| 15 | 756741 | 15.5% |
| 17 | 131 | < 0.1% |
| 18 | 105 | < 0.1% |
| 19 | 17 | < 0.1% |
| 21 | 43 | < 0.1% |
| 23 | 19 | < 0.1% |
| 24 | 181 | < 0.1% |
| Value | Count | Frequency (%) |
| 565 | 2 | < 0.1% |
| 564 | 13 | < 0.1% |
| 563 | 18 | < 0.1% |
| 561 | 7968 | 0.2% |
| 560 | 1876 | < 0.1% |
| 554 | 795 | < 0.1% |
| 551 | 23356 | |
| 550 | 6 | < 0.1% |
| 548 | 1 | < 0.1% |
| 544 | 1323 | < 0.1% |
ds_local_estoque
Text
| Distinct | 61 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 37.2 MiB |
Length
| Max length | 40 |
|---|---|
| Median length | 8 |
| Mean length | 14.344143 |
| Min length | 3 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Posto Carambeí |
|---|---|
| 2nd row | Almoxarifado |
| 3rd row | Almoxarifado Laboratório |
| 4th row | Almoxarifado |
| 5th row | Almoxarifado |
| Value | Count | Frequency (%) |
| farmacia | 3807982 | |
| centro | 1053715 | 11.0% |
| cirurgico | 1002612 | 10.5% |
| farmácia | 780097 | 8.2% |
| unimed | 756741 | 7.9% |
| 24 | 756741 | 7.9% |
| horas | 756741 | 7.9% |
| caf | 131285 | 1.4% |
| 90977 | 1.0% | |
| almoxarifado | 69681 | 0.7% |
| Other values (76) | 331172 | 3.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 13966229 | |
| r | 8516788 | |
| i | 7530444 | |
| c | 5625581 | |
| m | 5405483 | 7.7% |
| F | 4719382 | 6.7% |
| 4663030 | 6.7% | |
| o | 3093326 | 4.4% |
| C | 2295457 | 3.3% |
| e | 1883994 | 2.7% |
| Other values (53) | 12264415 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 69964129 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 13966229 | |
| r | 8516788 | |
| i | 7530444 | |
| c | 5625581 | |
| m | 5405483 | 7.7% |
| F | 4719382 | 6.7% |
| 4663030 | 6.7% | |
| o | 3093326 | 4.4% |
| C | 2295457 | 3.3% |
| e | 1883994 | 2.7% |
| Other values (53) | 12264415 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 69964129 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 13966229 | |
| r | 8516788 | |
| i | 7530444 | |
| c | 5625581 | |
| m | 5405483 | 7.7% |
| F | 4719382 | 6.7% |
| 4663030 | 6.7% | |
| o | 3093326 | 4.4% |
| C | 2295457 | 3.3% |
| e | 1883994 | 2.7% |
| Other values (53) | 12264415 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 69964129 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 13966229 | |
| r | 8516788 | |
| i | 7530444 | |
| c | 5625581 | |
| m | 5405483 | 7.7% |
| F | 4719382 | 6.7% |
| 4663030 | 6.7% | |
| o | 3093326 | 4.4% |
| C | 2295457 | 3.3% |
| e | 1883994 | 2.7% |
| Other values (53) | 12264415 |
cd_conta_contabil
Unsupported
Rejected Unsupported
| Missing | 85 |
|---|---|
| Missing (%) | < 0.1% |
| Memory size | 37.2 MiB |
nr_lote_contabil
Unsupported
Missing Rejected Unsupported
| Missing | 4877540 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 37.2 MiB |
ds_operacao
Categorical
High correlation Imbalance
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 37.2 MiB |
| Execução Prescrição | |
|---|---|
| Devolução Paciente | 276155 |
| Consumo | 124888 |
| Quebras e Contaminações | 2404 |
| Produtos vencidos | 2353 |
| Other values (7) | 3275 |
Length
| Max length | 36 |
|---|---|
| Median length | 19 |
| Mean length | 18.6399 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Consumo |
|---|---|
| 2nd row | Consumo |
| 3rd row | Consumo |
| 4th row | Consumo |
| 5th row | Consumo |
Common Values
| Value | Count | Frequency (%) |
| Execução Prescrição | 4468465 | |
| Devolução Paciente | 276155 | 5.7% |
| Consumo | 124888 | 2.6% |
| Quebras e Contaminações | 2404 | < 0.1% |
| Produtos vencidos | 2353 | < 0.1% |
| Perdas e Quebras | 1746 | < 0.1% |
| Quebras/Contaminação Med Controlados | 881 | < 0.1% |
| Perdas por estabilidade | 238 | < 0.1% |
| Sobras por estabilidade | 222 | < 0.1% |
| Medicamentos Controlados Vencidos | 125 | < 0.1% |
| Other values (2) | 63 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| execução | 4468465 | |
| prescrição | 4468465 | |
| devolução | 276155 | 2.9% |
| paciente | 276155 | 2.9% |
| consumo | 124888 | 1.3% |
| quebras | 4150 | < 0.1% |
| e | 4150 | < 0.1% |
| vencidos | 2478 | < 0.1% |
| contaminações | 2404 | < 0.1% |
| produtos | 2353 | < 0.1% |
| Other values (13) | 6250 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 9783556 | |
| o | 9754338 | |
| ç | 9216391 | |
| c | 9215814 | |
| ã | 9213966 | |
| r | 8948112 | |
| u | 4876892 | 5.4% |
| 4758373 | 5.2% | |
| i | 4751470 | 5.2% |
| P | 4748957 | 5.2% |
| Other values (22) | 15648987 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 90916856 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 9783556 | |
| o | 9754338 | |
| ç | 9216391 | |
| c | 9215814 | |
| ã | 9213966 | |
| r | 8948112 | |
| u | 4876892 | 5.4% |
| 4758373 | 5.2% | |
| i | 4751470 | 5.2% |
| P | 4748957 | 5.2% |
| Other values (22) | 15648987 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 90916856 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 9783556 | |
| o | 9754338 | |
| ç | 9216391 | |
| c | 9215814 | |
| ã | 9213966 | |
| r | 8948112 | |
| u | 4876892 | 5.4% |
| 4758373 | 5.2% | |
| i | 4751470 | 5.2% |
| P | 4748957 | 5.2% |
| Other values (22) | 15648987 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 90916856 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 9783556 | |
| o | 9754338 | |
| ç | 9216391 | |
| c | 9215814 | |
| ã | 9213966 | |
| r | 8948112 | |
| u | 4876892 | 5.4% |
| 4758373 | 5.2% | |
| i | 4751470 | 5.2% |
| P | 4748957 | 5.2% |
| Other values (22) | 15648987 |
cd_operacao
Real number (ℝ)
High correlation Skewed
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.1372702 |
| Minimum | 1 |
|---|---|
| Maximum | 141 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 37.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 4 |
| median | 4 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 141 |
| Range | 140 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.9696515 |
|---|---|
| Coefficient of variation (CV) | 0.95948566 |
| Kurtosis | 656.52644 |
| Mean | 4.1372702 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 25.009121 |
| Sum | 20179701 |
| Variance | 15.758133 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 4468465 | |
| 5 | 276155 | 5.7% |
| 1 | 124888 | 2.6% |
| 87 | 2404 | < 0.1% |
| 92 | 2353 | < 0.1% |
| 121 | 1746 | < 0.1% |
| 91 | 881 | < 0.1% |
| 137 | 238 | < 0.1% |
| 136 | 222 | < 0.1% |
| 93 | 125 | < 0.1% |
| Other values (2) | 63 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 124888 | 2.6% |
| 4 | 4468465 | |
| 5 | 276155 | 5.7% |
| 87 | 2404 | < 0.1% |
| 91 | 881 | < 0.1% |
| 92 | 2353 | < 0.1% |
| 93 | 125 | < 0.1% |
| 121 | 1746 | < 0.1% |
| 132 | 21 | < 0.1% |
| 136 | 222 | < 0.1% |
| Value | Count | Frequency (%) |
| 141 | 42 | < 0.1% |
| 137 | 238 | < 0.1% |
| 136 | 222 | < 0.1% |
| 132 | 21 | < 0.1% |
| 121 | 1746 | < 0.1% |
| 93 | 125 | < 0.1% |
| 92 | 2353 | < 0.1% |
| 91 | 881 | < 0.1% |
| 87 | 2404 | < 0.1% |
| 5 | 276155 |
dt_referencia
Date
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 37.2 MiB |
| Minimum | 2023-01-01 00:00:00 |
|---|---|
| Maximum | 2024-12-01 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
qt_estoque
Real number (ℝ)
High correlation Skewed
| Distinct | 1608 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.0178746 |
| Minimum | -3600 |
|---|---|
| Maximum | 990000 |
| Zeros | 124 |
| Zeros (%) | < 0.1% |
| Negative | 2653 |
| Negative (%) | 0.1% |
| Memory size | 37.2 MiB |
Quantile statistics
| Minimum | -3600 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 990000 |
| Range | 993600 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 449.46833 |
|---|---|
| Coefficient of variation (CV) | 148.93539 |
| Kurtosis | 4825458.8 |
| Mean | 3.0178746 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2190.8241 |
| Sum | 14719804 |
| Variance | 202021.78 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 4037789 | |
| 2 | 458130 | 9.4% |
| 3 | 96869 | 2.0% |
| 4 | 62103 | 1.3% |
| 5 | 48308 | 1.0% |
| 6 | 16237 | 0.3% |
| 10 | 11836 | 0.2% |
| 0.1 | 9020 | 0.2% |
| 0.083 | 8909 | 0.2% |
| 20 | 5698 | 0.1% |
| Other values (1598) | 122641 | 2.5% |
| Value | Count | Frequency (%) |
| -3600 | 1 | < 0.1% |
| -2500 | 1 | < 0.1% |
| -2350 | 1 | < 0.1% |
| -2000 | 3 | |
| -1500 | 1 | < 0.1% |
| -1495 | 1 | < 0.1% |
| -1300 | 1 | < 0.1% |
| -1263.19 | 1 | < 0.1% |
| -1250 | 1 | < 0.1% |
| -1205.64 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 990000 | 1 | < 0.1% |
| 9228 | 1 | < 0.1% |
| 6000 | 2 | < 0.1% |
| 4700 | 1 | < 0.1% |
| 4499 | 1 | < 0.1% |
| 4440 | 1 | < 0.1% |
| 4298 | 1 | < 0.1% |
| 4250 | 1 | < 0.1% |
| 4000 | 11 | |
| 3800 | 1 | < 0.1% |
vl_estoque
Real number (ℝ)
High correlation Skewed
| Distinct | 24549 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.205163 |
| Minimum | -35475 |
|---|---|
| Maximum | 376210.29 |
| Zeros | 972 |
| Zeros (%) | < 0.1% |
| Negative | 2936 |
| Negative (%) | 0.1% |
| Memory size | 37.2 MiB |
Quantile statistics
| Minimum | -35475 |
|---|---|
| 5-th percentile | 0.2 |
| Q1 | 0.42 |
| median | 1.22 |
| Q3 | 4.15 |
| 95-th percentile | 24.18 |
| Maximum | 376210.29 |
| Range | 411685.29 |
| Interquartile range (IQR) | 3.73 |
Descriptive statistics
| Standard deviation | 970.87769 |
|---|---|
| Coefficient of variation (CV) | 43.723061 |
| Kurtosis | 97058.845 |
| Mean | 22.205163 |
| Median Absolute Deviation (MAD) | 1.01 |
| Skewness | 271.00427 |
| Sum | 1.0830657 × 108 |
| Variance | 942603.49 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.2 | 249510 | 5.1% |
| 0.21 | 157349 | 3.2% |
| 0.53 | 133199 | 2.7% |
| 0.28 | 105235 | 2.2% |
| 1 | 104299 | 2.1% |
| 3.93 | 96541 | 2.0% |
| 0.5 | 85429 | 1.8% |
| 0.33 | 80540 | 1.7% |
| 0.52 | 77710 | 1.6% |
| 0.83 | 64205 | 1.3% |
| Other values (24539) | 3723523 |
| Value | Count | Frequency (%) |
| -35475 | 1 | |
| -18045.55 | 1 | |
| -17223.41 | 1 | |
| -14352.84 | 2 | |
| -11772.13 | 1 | |
| -11170 | 1 | |
| -10222.94 | 1 | |
| -9809.99 | 1 | |
| -9253.34 | 1 | |
| -9070.1 | 1 |
| Value | Count | Frequency (%) |
| 376210.29 | 8 | |
| 360009.85 | 12 | |
| 340918.42 | 4 | < 0.1% |
| 176334.65 | 1 | < 0.1% |
| 153859.88 | 1 | < 0.1% |
| 130120 | 2 | < 0.1% |
| 110700 | 1 | < 0.1% |
| 101708.52 | 1 | < 0.1% |
| 99222.64 | 1 | < 0.1% |
| 94593.87 | 1 | < 0.1% |
vl_movimento
Real number (ℝ)
High correlation Skewed
| Distinct | 24549 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.205163 |
| Minimum | -35475 |
|---|---|
| Maximum | 376210.29 |
| Zeros | 972 |
| Zeros (%) | < 0.1% |
| Negative | 2936 |
| Negative (%) | 0.1% |
| Memory size | 37.2 MiB |
Quantile statistics
| Minimum | -35475 |
|---|---|
| 5-th percentile | 0.2 |
| Q1 | 0.42 |
| median | 1.22 |
| Q3 | 4.15 |
| 95-th percentile | 24.18 |
| Maximum | 376210.29 |
| Range | 411685.29 |
| Interquartile range (IQR) | 3.73 |
Descriptive statistics
| Standard deviation | 970.87769 |
|---|---|
| Coefficient of variation (CV) | 43.723061 |
| Kurtosis | 97058.845 |
| Mean | 22.205163 |
| Median Absolute Deviation (MAD) | 1.01 |
| Skewness | 271.00427 |
| Sum | 1.0830657 × 108 |
| Variance | 942603.49 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.2 | 249510 | 5.1% |
| 0.21 | 157349 | 3.2% |
| 0.53 | 133199 | 2.7% |
| 0.28 | 105235 | 2.2% |
| 1 | 104299 | 2.1% |
| 3.93 | 96541 | 2.0% |
| 0.5 | 85429 | 1.8% |
| 0.33 | 80540 | 1.7% |
| 0.52 | 77710 | 1.6% |
| 0.83 | 64205 | 1.3% |
| Other values (24539) | 3723523 |
| Value | Count | Frequency (%) |
| -35475 | 1 | |
| -18045.55 | 1 | |
| -17223.41 | 1 | |
| -14352.84 | 2 | |
| -11772.13 | 1 | |
| -11170 | 1 | |
| -10222.94 | 1 | |
| -9809.99 | 1 | |
| -9253.34 | 1 | |
| -9070.1 | 1 |
| Value | Count | Frequency (%) |
| 376210.29 | 8 | |
| 360009.85 | 12 | |
| 340918.42 | 4 | < 0.1% |
| 176334.65 | 1 | < 0.1% |
| 153859.88 | 1 | < 0.1% |
| 130120 | 2 | < 0.1% |
| 110700 | 1 | < 0.1% |
| 101708.52 | 1 | < 0.1% |
| 99222.64 | 1 | < 0.1% |
| 94593.87 | 1 | < 0.1% |
vl_consumo
Real number (ℝ)
High correlation Skewed
| Distinct | 27585 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.434551 |
| Minimum | -71357.13 |
|---|---|
| Maximum | 376210.29 |
| Zeros | 8894 |
| Zeros (%) | 0.2% |
| Negative | 278733 |
| Negative (%) | 5.7% |
| Memory size | 37.2 MiB |
Quantile statistics
| Minimum | -71357.13 |
|---|---|
| 5-th percentile | -0.24 |
| Q1 | 0.34 |
| median | 1.06 |
| Q3 | 3.93 |
| 95-th percentile | 23.04 |
| Maximum | 376210.29 |
| Range | 447567.42 |
| Interquartile range (IQR) | 3.59 |
Descriptive statistics
| Standard deviation | 967.73663 |
|---|---|
| Coefficient of variation (CV) | 47.357861 |
| Kurtosis | 98195.714 |
| Mean | 20.434551 |
| Median Absolute Deviation (MAD) | 0.86 |
| Skewness | 271.8533 |
| Sum | 99670340 |
| Variance | 936514.18 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.2 | 236099 | 4.8% |
| 0.21 | 148809 | 3.1% |
| 0.53 | 125250 | 2.6% |
| 0.28 | 101664 | 2.1% |
| 1 | 99080 | 2.0% |
| 3.93 | 90394 | 1.9% |
| 0.5 | 80524 | 1.7% |
| 0.33 | 75667 | 1.6% |
| 0.52 | 72703 | 1.5% |
| 0.83 | 60578 | 1.2% |
| Other values (27575) | 3786772 |
| Value | Count | Frequency (%) |
| -71357.13 | 1 | < 0.1% |
| -67800 | 1 | < 0.1% |
| -45651.89 | 1 | < 0.1% |
| -44762.1 | 1 | < 0.1% |
| -44637.26 | 1 | < 0.1% |
| -40678.56 | 1 | < 0.1% |
| -37771.46 | 1 | < 0.1% |
| -37682.32 | 4 | |
| -36157.44 | 1 | < 0.1% |
| -35475 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 376210.29 | 8 | |
| 360009.85 | 12 | |
| 340918.42 | 4 | < 0.1% |
| 176334.65 | 1 | < 0.1% |
| 130120 | 2 | < 0.1% |
| 110700 | 1 | < 0.1% |
| 101708.52 | 1 | < 0.1% |
| 99222.64 | 1 | < 0.1% |
| 94593.87 | 1 | < 0.1% |
| 86819.81 | 1 | < 0.1% |
qt_consumo
Real number (ℝ)
High correlation Skewed
| Distinct | 1316 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.8967214 |
| Minimum | -3600 |
|---|---|
| Maximum | 990000 |
| Zeros | 14751 |
| Zeros (%) | 0.3% |
| Negative | 278312 |
| Negative (%) | 5.7% |
| Memory size | 37.2 MiB |
Quantile statistics
| Minimum | -3600 |
|---|---|
| 5-th percentile | -1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 990000 |
| Range | 993600 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 449.43989 |
|---|---|
| Coefficient of variation (CV) | 155.15468 |
| Kurtosis | 4826682.9 |
| Mean | 2.8967214 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2191.2389 |
| Sum | 14128875 |
| Variance | 201996.21 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 3626739 | |
| 2 | 571320 | 11.7% |
| -1 | 210989 | 4.3% |
| 3 | 110801 | 2.3% |
| 4 | 67237 | 1.4% |
| -2 | 47951 | 1.0% |
| 5 | 47397 | 1.0% |
| 6 | 16188 | 0.3% |
| 0 | 14751 | 0.3% |
| 0.08 | 12989 | 0.3% |
| Other values (1306) | 151178 | 3.1% |
| Value | Count | Frequency (%) |
| -3600 | 1 | < 0.1% |
| -2500 | 1 | < 0.1% |
| -2000 | 3 | |
| -1500 | 1 | < 0.1% |
| -1495 | 1 | < 0.1% |
| -1300 | 1 | < 0.1% |
| -1263.19 | 1 | < 0.1% |
| -1250 | 1 | < 0.1% |
| -1205.64 | 1 | < 0.1% |
| -1200 | 2 |
| Value | Count | Frequency (%) |
| 990000 | 1 | < 0.1% |
| 6000 | 2 | < 0.1% |
| 4700 | 1 | < 0.1% |
| 4499 | 1 | < 0.1% |
| 4298 | 1 | < 0.1% |
| 4250 | 1 | < 0.1% |
| 4000 | 11 | |
| 3800 | 1 | < 0.1% |
| 3700 | 2 | < 0.1% |
| 3600 | 5 |
vl_movimento_2
Real number (ℝ)
High correlation Skewed
| Distinct | 27585 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.434551 |
| Minimum | -71357.13 |
|---|---|
| Maximum | 376210.29 |
| Zeros | 8894 |
| Zeros (%) | 0.2% |
| Negative | 278733 |
| Negative (%) | 5.7% |
| Memory size | 37.2 MiB |
Quantile statistics
| Minimum | -71357.13 |
|---|---|
| 5-th percentile | -0.24 |
| Q1 | 0.34 |
| median | 1.06 |
| Q3 | 3.93 |
| 95-th percentile | 23.04 |
| Maximum | 376210.29 |
| Range | 447567.42 |
| Interquartile range (IQR) | 3.59 |
Descriptive statistics
| Standard deviation | 967.73663 |
|---|---|
| Coefficient of variation (CV) | 47.357861 |
| Kurtosis | 98195.714 |
| Mean | 20.434551 |
| Median Absolute Deviation (MAD) | 0.86 |
| Skewness | 271.8533 |
| Sum | 99670340 |
| Variance | 936514.18 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.2 | 236099 | 4.8% |
| 0.21 | 148809 | 3.1% |
| 0.53 | 125250 | 2.6% |
| 0.28 | 101664 | 2.1% |
| 1 | 99080 | 2.0% |
| 3.93 | 90394 | 1.9% |
| 0.5 | 80524 | 1.7% |
| 0.33 | 75667 | 1.6% |
| 0.52 | 72703 | 1.5% |
| 0.83 | 60578 | 1.2% |
| Other values (27575) | 3786772 |
| Value | Count | Frequency (%) |
| -71357.13 | 1 | < 0.1% |
| -67800 | 1 | < 0.1% |
| -45651.89 | 1 | < 0.1% |
| -44762.1 | 1 | < 0.1% |
| -44637.26 | 1 | < 0.1% |
| -40678.56 | 1 | < 0.1% |
| -37771.46 | 1 | < 0.1% |
| -37682.32 | 4 | |
| -36157.44 | 1 | < 0.1% |
| -35475 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 376210.29 | 8 | |
| 360009.85 | 12 | |
| 340918.42 | 4 | < 0.1% |
| 176334.65 | 1 | < 0.1% |
| 130120 | 2 | < 0.1% |
| 110700 | 1 | < 0.1% |
| 101708.52 | 1 | < 0.1% |
| 99222.64 | 1 | < 0.1% |
| 94593.87 | 1 | < 0.1% |
| 86819.81 | 1 | < 0.1% |
id_item
Real number (ℝ)
High correlation
| Distinct | 3637 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.4488245 × 109 |
| Minimum | 691022 |
|---|---|
| Maximum | 6.9102797 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 37.2 MiB |
Quantile statistics
| Minimum | 691022 |
|---|---|
| 5-th percentile | 6910269 |
| Q1 | 69102238 |
| median | 6.9102424 × 108 |
| Q3 | 6.9102521 × 109 |
| 95-th percentile | 6.9102739 × 109 |
| Maximum | 6.9102797 × 109 |
| Range | 6.9095887 × 109 |
| Interquartile range (IQR) | 6.8411499 × 109 |
Descriptive statistics
| Standard deviation | 3.3515037 × 109 |
|---|---|
| Coefficient of variation (CV) | 0.97178145 |
| Kurtosis | -1.9829233 |
| Mean | 3.4488245 × 109 |
| Median Absolute Deviation (MAD) | 6.8411397 × 108 |
| Skewness | 0.057288802 |
| Sum | 1.6821779 × 1016 |
| Variance | 1.1232577 × 1019 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6910251823 | 540978 | 11.1% |
| 6910269 | 328797 | 6.7% |
| 691022358 | 286057 | 5.9% |
| 6910268 | 167287 | 3.4% |
| 6910253709 | 156174 | 3.2% |
| 69102342 | 153863 | 3.2% |
| 6910290 | 140266 | 2.9% |
| 6910211325 | 116066 | 2.4% |
| 69102193 | 107909 | 2.2% |
| 6910273864 | 92689 | 1.9% |
| Other values (3627) | 2787454 |
| Value | Count | Frequency (%) |
| 691022 | 60 | < 0.1% |
| 6910232 | 1258 | < 0.1% |
| 6910235 | 1569 | < 0.1% |
| 6910236 | 1298 | < 0.1% |
| 6910237 | 181 | < 0.1% |
| 6910238 | 1503 | < 0.1% |
| 6910240 | 7492 | 0.2% |
| 6910255 | 6775 | 0.1% |
| 6910261 | 16 | < 0.1% |
| 6910268 | 167287 |
| Value | Count | Frequency (%) |
| 6910279674 | 1 | < 0.1% |
| 6910279629 | 1 | < 0.1% |
| 6910279628 | 1 | < 0.1% |
| 6910279594 | 1 | < 0.1% |
| 6910279574 | 1 | < 0.1% |
| 6910279548 | 156 | |
| 6910279547 | 24 | < 0.1% |
| 6910279546 | 66 | |
| 6910279545 | 63 | |
| 6910279534 | 2 | < 0.1% |
Interactions
Correlations
| cd_acao | cd_centro_custo | cd_local_estoque | cd_material | cd_operacao | ds_estabelecimento | ds_operacao | id_item | nr_atendimento | qt_consumo | qt_estoque | vl_consumo | vl_estoque | vl_movimento | vl_movimento_2 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| cd_acao | 1.000 | 0.047 | 0.058 | 0.027 | 0.049 | 0.061 | 0.130 | 0.015 | 0.024 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| cd_centro_custo | 0.047 | 1.000 | 0.203 | 0.010 | -0.040 | 0.595 | 0.236 | 0.010 | -0.008 | 0.019 | 0.035 | 0.027 | 0.042 | 0.042 | 0.027 |
| cd_local_estoque | 0.058 | 0.203 | 1.000 | 0.033 | -0.148 | 0.624 | 0.228 | 0.033 | 0.066 | 0.137 | 0.134 | 0.293 | 0.301 | 0.301 | 0.293 |
| cd_material | 0.027 | 0.010 | 0.033 | 1.000 | -0.098 | 0.068 | 0.065 | 1.000 | 0.003 | 0.066 | 0.059 | 0.197 | 0.207 | 0.207 | 0.197 |
| cd_operacao | 0.049 | -0.040 | -0.148 | -0.098 | 1.000 | 0.005 | 1.000 | -0.098 | 0.051 | -0.556 | -0.158 | -0.451 | -0.136 | -0.136 | -0.451 |
| ds_estabelecimento | 0.061 | 0.595 | 0.624 | 0.068 | 0.005 | 1.000 | 0.264 | 0.061 | 0.051 | 0.000 | 0.000 | 0.000 | 0.001 | 0.001 | 0.000 |
| ds_operacao | 0.130 | 0.236 | 0.228 | 0.065 | 1.000 | 0.264 | 1.000 | 0.107 | 0.065 | 0.002 | 0.002 | 0.012 | 0.017 | 0.017 | 0.012 |
| id_item | 0.015 | 0.010 | 0.033 | 1.000 | -0.098 | 0.061 | 0.107 | 1.000 | 0.003 | 0.066 | 0.059 | 0.197 | 0.207 | 0.207 | 0.197 |
| nr_atendimento | 0.024 | -0.008 | 0.066 | 0.003 | 0.051 | 0.051 | 0.065 | 0.003 | 1.000 | -0.016 | 0.011 | -0.030 | -0.009 | -0.009 | -0.030 |
| qt_consumo | 0.000 | 0.019 | 0.137 | 0.066 | -0.556 | 0.000 | 0.002 | 0.066 | -0.016 | 1.000 | 0.763 | 0.418 | 0.228 | 0.228 | 0.418 |
| qt_estoque | 0.000 | 0.035 | 0.134 | 0.059 | -0.158 | 0.000 | 0.002 | 0.059 | 0.011 | 0.763 | 1.000 | 0.268 | 0.285 | 0.285 | 0.268 |
| vl_consumo | 0.000 | 0.027 | 0.293 | 0.197 | -0.451 | 0.000 | 0.012 | 0.197 | -0.030 | 0.418 | 0.268 | 1.000 | 0.897 | 0.897 | 1.000 |
| vl_estoque | 0.000 | 0.042 | 0.301 | 0.207 | -0.136 | 0.001 | 0.017 | 0.207 | -0.009 | 0.228 | 0.285 | 0.897 | 1.000 | 1.000 | 0.897 |
| vl_movimento | 0.000 | 0.042 | 0.301 | 0.207 | -0.136 | 0.001 | 0.017 | 0.207 | -0.009 | 0.228 | 0.285 | 0.897 | 1.000 | 1.000 | 0.897 |
| vl_movimento_2 | 0.000 | 0.027 | 0.293 | 0.197 | -0.451 | 0.000 | 0.012 | 0.197 | -0.030 | 0.418 | 0.268 | 1.000 | 0.897 | 0.897 | 1.000 |
Missing values
Sample
| ds_centro_custo | cd_centro_custo | ds_estabelecimento | cd_material | cd_acao | nr_atendimento | dt_movimento_estoque | cd_local_estoque | ds_local_estoque | cd_conta_contabil | nr_lote_contabil | ds_operacao | cd_operacao | dt_referencia | qt_estoque | vl_estoque | vl_movimento | vl_consumo | qt_consumo | vl_movimento_2 | id_item | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Posto Carambeí | 9722 | Laboratorio Unimed Ponta Grossa | 49862 | 1 | NaN | 2024-10-17 15:46:02.000 | 537 | Posto Carambeí | 71111911113905.0 | NaN | Consumo | 1 | 2024-10-01 00:00:00.000 | 1.0 | 1.89 | 1.89 | 1.89 | 1.0 | 1.89 | 6910249862 |
| 1 | SADT - RADIOLOGIA | 9112 | Hospital Geral Unimed | 42281 | 1 | NaN | 2024-10-17 13:49:55.000 | 11 | Almoxarifado | 71111911113905.0 | NaN | Consumo | 1 | 2024-10-01 00:00:00.000 | 3.0 | 64.35 | 64.35 | 64.35 | 3.0 | 64.35 | 6910242281 |
| 2 | Coleta Ambulatorial | 9765 | Laboratorio Unimed Ponta Grossa | 36215 | 1 | NaN | 2024-10-09 10:29:11.000 | 62 | Almoxarifado Laboratório | 71111911113103.0 | NaN | Consumo | 1 | 2024-10-01 00:00:00.000 | 500.0 | 13.35 | 13.35 | 13.35 | 500.0 | 13.35 | 6910236215 |
| 3 | 3º ANDAR - UNIDADE DE INTERNAÇÃO | 9103 | Hospital Geral Unimed | 69295 | 1 | NaN | 2024-10-17 14:04:47.000 | 11 | Almoxarifado | 71111911113905.0 | NaN | Consumo | 1 | 2024-10-01 00:00:00.000 | 20.0 | 44.00 | 44.00 | 44.00 | 20.0 | 44.00 | 6910269295 |
| 4 | 3º ANDAR - UNIDADE DE INTERNAÇÃO | 9103 | Hospital Geral Unimed | 16810 | 1 | NaN | 2024-10-17 14:04:47.000 | 11 | Almoxarifado | 71111911113905.0 | NaN | Consumo | 1 | 2024-10-01 00:00:00.000 | 1.0 | 1.82 | 1.82 | 1.82 | 1.0 | 1.82 | 6910216810 |
| 5 | 3º ANDAR - UNIDADE DE INTERNAÇÃO | 9103 | Hospital Geral Unimed | 52306 | 1 | NaN | 2024-10-15 11:38:04.000 | 57 | CAF | 71111911113103.0 | NaN | Consumo | 1 | 2024-10-01 00:00:00.000 | 6.0 | 63.42 | 63.42 | 63.42 | 6.0 | 63.42 | 6910252306 |
| 6 | MANUTENÇÃO | 9312 | Hospital Geral Unimed | 32032 | 1 | NaN | 2024-10-17 13:33:48.000 | 11 | Almoxarifado | 71111911113904.0 | NaN | Consumo | 1 | 2024-10-01 00:00:00.000 | 1.0 | 5.03 | 5.03 | 5.03 | 1.0 | 5.03 | 6910232032 |
| 7 | UNIMED 24 HORAS | 9109 | Hospital Geral Unimed | 42281 | 1 | NaN | 2024-10-17 14:07:53.000 | 11 | Almoxarifado | 71111911113905.0 | NaN | Consumo | 1 | 2024-10-01 00:00:00.000 | 15.0 | 321.75 | 321.75 | 321.75 | 15.0 | 321.75 | 6910242281 |
| 8 | SADT - TOMOGRAFIA UNIMED | 9135 | Hospital Geral Unimed | 70598 | 1 | NaN | 2024-10-15 15:55:55.000 | 57 | CAF | 71111911113103.0 | NaN | Consumo | 1 | 2024-10-01 00:00:00.000 | 10.0 | 773.62 | 773.62 | 773.62 | 10.0 | 773.62 | 6910270598 |
| 9 | SADT - TOMOGRAFIA UNIMED | 9135 | Hospital Geral Unimed | 77422 | 1 | NaN | 2024-10-15 15:55:55.000 | 57 | CAF | 71111911113103.0 | NaN | Consumo | 1 | 2024-10-01 00:00:00.000 | 10.0 | 1020.00 | 1020.00 | 1020.00 | 10.0 | 1020.00 | 6910277422 |
| ds_centro_custo | cd_centro_custo | ds_estabelecimento | cd_material | cd_acao | nr_atendimento | dt_movimento_estoque | cd_local_estoque | ds_local_estoque | cd_conta_contabil | nr_lote_contabil | ds_operacao | cd_operacao | dt_referencia | qt_estoque | vl_estoque | vl_movimento | vl_consumo | qt_consumo | vl_movimento_2 | id_item | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4877530 | FARMÁCIA CENTRAL | 9306 | Hospital Geral Unimed | 1099 | 1 | NaN | 2023-04-10 05:58:43.000 | 19 | Carrinho de emergência - 3° A Torre I | NaN | NaN | Perdas por estabilidade | 137 | 2023-04-01 00:00:00.000 | 1.000 | 6.51 | 6.51 | 0.00 | 0.0 | 0.00 | 691021099 |
| 4877531 | FARMÁCIA CENTRAL | 9306 | Hospital Geral Unimed | 68439 | 2 | NaN | 2023-02-02 15:18:19.000 | 1 | Farmacia | 71111911113206.0 | NaN | Perdas por estabilidade | 137 | 2023-02-01 00:00:00.000 | -0.250 | -0.50 | -0.50 | 0.00 | 0.0 | 0.00 | 6910268439 |
| 4877532 | FARMÁCIA CENTRAL | 9306 | Hospital Geral Unimed | 54079 | 1 | NaN | 2023-02-07 12:17:03.000 | 1 | Farmacia | 71111911113206.0 | NaN | Perdas por estabilidade | 137 | 2023-02-01 00:00:00.000 | 0.400 | 2.58 | 2.58 | 0.00 | 0.0 | 0.00 | 6910254079 |
| 4877533 | FARMÁCIA CENTRAL | 9306 | Hospital Geral Unimed | 880 | 1 | NaN | 2023-01-26 10:49:11.000 | 1 | Farmacia | 71111911113206.0 | NaN | Perdas por estabilidade | 137 | 2023-01-01 00:00:00.000 | 0.083 | 1.36 | 1.36 | 0.00 | 0.0 | 0.00 | 69102880 |
| 4877534 | FARMÁCIA CENTRAL | 9306 | Hospital Geral Unimed | 880 | 2 | NaN | 2023-01-26 10:49:11.000 | 1 | Farmacia | 71111911113206.0 | NaN | Perdas por estabilidade | 137 | 2023-01-01 00:00:00.000 | -0.083 | -1.35 | -1.35 | 0.00 | 0.0 | 0.00 | 69102880 |
| 4877535 | FARMÁCIA CENTRAL | 9306 | Hospital Geral Unimed | 51226 | 1 | NaN | 2023-12-12 14:24:43.000 | 57 | CAF | 71111911113105.0 | NaN | Saída por troca comercial | 141 | 2023-12-01 00:00:00.000 | 3.000 | 40.50 | 40.50 | -40.50 | -3.0 | -40.50 | 6910251226 |
| 4877536 | FARMÁCIA CENTRAL | 9306 | Hospital Geral Unimed | 55434 | 1 | NaN | 2023-12-12 14:19:59.000 | 57 | CAF | 71111911113105.0 | NaN | Saída por troca comercial | 141 | 2023-12-01 00:00:00.000 | 2.000 | 34.49 | 34.49 | -34.49 | -2.0 | -34.49 | 6910255434 |
| 4877537 | FARMÁCIA CENTRAL | 9306 | Hospital Geral Unimed | 3081 | 1 | NaN | 2023-11-24 16:32:22.000 | 57 | CAF | 71111911113205.0 | NaN | Saída por troca comercial | 141 | 2023-11-01 00:00:00.000 | 10.000 | 26.08 | 26.08 | -26.08 | -10.0 | -26.08 | 691023081 |
| 4877538 | FARMÁCIA CENTRAL | 9306 | Hospital Geral Unimed | 71276 | 1 | NaN | 2023-11-24 16:53:57.000 | 57 | CAF | 71111911113205.0 | NaN | Saída por troca comercial | 141 | 2023-11-01 00:00:00.000 | 1.000 | 558.48 | 558.48 | -558.48 | -1.0 | -558.48 | 6910271276 |
| 4877539 | FARMÁCIA CENTRAL | 9306 | Hospital Geral Unimed | 54736 | 1 | NaN | 2023-11-24 16:42:44.000 | 57 | CAF | 71111911113105.0 | NaN | Saída por troca comercial | 141 | 2023-11-01 00:00:00.000 | 1.000 | 2.00 | 2.00 | -2.00 | -1.0 | -2.00 | 6910254736 |
Duplicate rows
Most frequently occurring
| ds_centro_custo | cd_centro_custo | ds_estabelecimento | cd_material | cd_acao | nr_atendimento | dt_movimento_estoque | cd_local_estoque | ds_local_estoque | ds_operacao | cd_operacao | dt_referencia | qt_estoque | vl_estoque | vl_movimento | vl_consumo | qt_consumo | vl_movimento_2 | id_item | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 3º ANDAR - UNIDADE DE INTERNAÇÃO | 9103 | Hospital Geral Unimed | 76033 | 1 | 1992821.0 | 2023-04-20 08:09:48.000 | 1 | Farmacia | Devolução Paciente | 5 | 2023-04-01 00:00:00.000 | 0.000 | 0.00 | 0.00 | 0.00 | 0.0 | 0.00 | 6910276033 | 2 |
| 1 | CENTRO CIRÚRGICO | 9108 | Hospital Geral Unimed | 75306 | 1 | 2156754.0 | 2023-10-08 16:22:08.000 | 509 | OPME Centro Cirúrgico | Execução Prescrição | 4 | 2023-10-01 00:00:00.000 | 1.000 | 70.00 | 70.00 | 70.00 | 1.0 | 70.00 | 6910275306 | 2 |
| 2 | UNICON - UNIMED CENTRO DE ONCOLOGIA | 9110 | Hospital Geral Unimed | 123 | 1 | 2144390.0 | 2023-10-06 11:00:00.000 | 57 | CAF | Execução Prescrição | 4 | 2023-10-01 00:00:00.000 | 1.000 | 1.32 | 1.32 | 1.32 | 1.0 | 1.32 | 69102123 | 2 |
| 3 | UNICON - UNIMED CENTRO DE ONCOLOGIA | 9110 | Hospital Geral Unimed | 2358 | 1 | 2144390.0 | 2023-10-06 11:00:00.000 | 57 | CAF | Execução Prescrição | 4 | 2023-10-01 00:00:00.000 | 3.000 | 0.90 | 0.90 | 0.90 | 3.0 | 0.90 | 691022358 | 2 |
| 4 | UNICON - UNIMED CENTRO DE ONCOLOGIA | 9110 | Hospital Geral Unimed | 51790 | 1 | 2144390.0 | 2023-10-06 11:00:00.000 | 57 | CAF | Execução Prescrição | 4 | 2023-10-01 00:00:00.000 | 1.000 | 1.56 | 1.56 | 1.56 | 1.0 | 1.56 | 6910251790 | 2 |
| 5 | UNICON - UNIMED CENTRO DE ONCOLOGIA | 9110 | Hospital Geral Unimed | 60080 | 1 | 1930852.0 | 2023-01-24 10:00:25.000 | 57 | CAF | Devolução Paciente | 5 | 2023-01-01 00:00:00.000 | 0.000 | 5.00 | 5.00 | -5.00 | -0.1 | -5.00 | 6910260080 | 2 |
| 6 | UNICON - UNIMED CENTRO DE ONCOLOGIA | 9110 | Hospital Geral Unimed | 60080 | 1 | 1930852.0 | 2023-01-24 10:00:25.000 | 57 | CAF | Devolução Paciente | 5 | 2023-01-01 00:00:00.000 | 0.002 | 5.72 | 5.72 | -5.72 | -0.1 | -5.72 | 6910260080 | 2 |
| 7 | UNICON - UNIMED CENTRO DE ONCOLOGIA | 9110 | Hospital Geral Unimed | 60080 | 1 | 1930852.0 | 2023-01-24 10:00:25.000 | 57 | CAF | Devolução Paciente | 5 | 2023-01-01 00:00:00.000 | 0.003 | 5.46 | 5.46 | -5.46 | -0.1 | -5.46 | 6910260080 | 2 |
| 8 | UNICON - UNIMED CENTRO DE ONCOLOGIA | 9110 | Hospital Geral Unimed | 60080 | 1 | 1930852.0 | 2023-01-24 10:00:25.000 | 57 | CAF | Devolução Paciente | 5 | 2023-01-01 00:00:00.000 | 0.003 | 5.61 | 5.61 | -5.61 | -0.1 | -5.61 | 6910260080 | 2 |
| 9 | UNICON - UNIMED CENTRO DE ONCOLOGIA | 9110 | Hospital Geral Unimed | 60080 | 1 | 1930852.0 | 2023-01-24 10:00:25.000 | 57 | CAF | Execução Prescrição | 4 | 2023-01-01 00:00:00.000 | 0.000 | 5.00 | 5.00 | 5.00 | 0.1 | 5.00 | 6910260080 | 2 |